<?php include_once "header.php"; ?>

<?php
	// houses
	echo "<h2>Houses</h2>";
	$houses_query = mysql_query("SELECT * FROM `house` ORDER BY `name`");
	while ($house = mysql_fetch_assoc($houses_query)) {
		echo "<img src=\"images/houses/" . strtolower(str_replace(" ", "-", $house['name'])) . ".png\" alt=\"" . $house['name'] . "\"/><br/>";
	}
	
	// Careers
	echo "<h2>Careers</h2>";
	$careers_query = mysql_query("SELECT * FROM `career` ORDER BY `name`");
	while ($career = mysql_fetch_assoc($careers_query)) {
		echo "<img src=\"images/careers/" . strtolower(str_replace(" ", "-", $career['name'])) . ".png\" alt=\"" . $career['name'] . "\"/><br/>";
	}
	
	// Stocks
	echo "<h2>Stocks</h2>";
	for ($i=1; $i<10; ++$i) {
		echo "<img src=\"images/stocks/$i.png\" alt=\"$i\"/>";
	}
?>

<?php include_once "footer.php"; ?>
